Key test

Key test lets you run a uniqueness test on the current database. You are asked to select one or more fields in the current database (just as in Order and Project). Key test combines these fields for each record to produce a key for each record. Then it tests if every record has a different key. If some records have the same key, you enter a menu where you can specify (with show to delete) that you want to select some records for deletion. (See section [*] on how to make a selection.) Alternatively, you can ask for the next key which appears in more that one record, or finish the Key test operation deleting records as indicated sofar, or exit the operation without any change.

If you don't select any fields, Key test will report on records that appear two or more times in the current database.